Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/vsumcuracc.sql

Text File | 2000-05-12 | 460b | 15 lines

/*
This view sums the curacc data for a particular conversion segment.
*/
create or replace view vsumCuracc as
select vcurstaterange.conversion_num,
    vcurstaterange.open_count,
    vcurstaterange.close_count,
    vcurstaterange.cashbox_glid,
    sum(curacc.currency_val) probedcash
from vcurstaterange, curacc
where curacc.det_seq_num between open_count and close_count
group by conversion_num, open_count, close_count,vcurstaterange.cashbox_glid;